package com.xie.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xie.pojo.Bed;
import com.xie.pojo.Vo.RoomVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
@Mapper
public interface BedDao  extends BaseMapper<Bed> {
 @Select("SELECT room.room_no,room.room_judge,bed.bed_no,bed.bed_judge,paitient.paitient_name FROM room,bed,paitient "
         +"where bed.bed_no = paitient.paitient_bed")
    List<RoomVo> findRoomT(); //查询指定房间里的病床、病人信息
}
